Tabela ExternalIdentifier

Definicja tabeli ExternalIdentifier

Name

ExternalIdentifier

Code

ExternalIdentifier

Comment

PL: Identyfikatory dokumentów (np numery faktur)
EN: Documents identificators (fe. Infoices numbers)


Lista kolumn tabeli ExternalIdentifier

Name

Code

IdentifierTypeID

IdentifierTypeID

ExternalValue

ExternalValue

LocationID

LocationID

NextExternalIdentifierID

NextExternalIdentifierID

CNStatusID

CNStatusID

CNFolderID

CNFolderID

StartDT

StartDT

StopDT

StopDT

Active

Active

Comments

Comments

Value

Value

InsertingPerson

InsertingPerson

InsertDate

InsertDate

LastModifiedPerson

LastModifiedPerson

LastModifiedDT

LastModifiedDT

RemovingPerson

RemovingPerson

Prefix

Prefix

RotomatAddress

RotomatAddress

OpenNumber

OpenNumber

Suffix

Suffix


Kolumna IdentifierTypeID tabeli ExternalIdentifier

Definicja kolumny IdentifierTypeID tabeli ExternalIdentifier

Name

IdentifierTypeID

Code

IdentifierTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ExternalValue tabeli ExternalIdentifier

Definicja kolumny ExternalValue tabeli ExternalIdentifier

Name

ExternalValue

Code

ExternalValue

Data Type

VARCHAR2(64)

Mandatory

Yes

Comment

 


Kolumna LocationID tabeli ExternalIdentifier

Definicja kolumny LocationID tabeli ExternalIdentifier

Name

LocationID

Code

LocationID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna NextExternalIdentifierID tabeli ExternalIdentifier

Definicja kolumny NextExternalIdentifierID tabeli ExternalIdentifier

Name

NextExternalIdentifierID

Code

NextExternalIdentifierID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CNStatusID tabeli ExternalIdentifier

Definicja kolumny CNStatusID tabeli ExternalIdentifier

Name

CNStatusID

Code

CNStatusID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna CNFolderID tabeli ExternalIdentifier

Definicja kolumny CNFolderID tabeli ExternalIdentifier

Name

CNFolderID

Code

CNFolderID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StartDT tabeli ExternalIdentifier

Definicja kolumny StartDT tabeli ExternalIdentifier

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli ExternalIdentifier

Definicja kolumny StopDT tabeli ExternalIdentifier

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Kolumna Active tabeli ExternalIdentifier

Definicja kolumny Active tabeli ExternalIdentifier

Name

Active

Code

Active

Data Type

NUMBER(5)

Mandatory

No

Comment

PL: Aktywnosc wiersza.
EN: Record's Activity
DE: Aktivitat des Rekord


Kolumna Comments tabeli ExternalIdentifier

Definicja kolumny Comments tabeli ExternalIdentifier

Name

Comments

Code

Comments

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna Value tabeli ExternalIdentifier

Definicja kolumny Value tabeli ExternalIdentifier

Name

Value

Code

Value

Data Type

NUMBER(32,1)

Mandatory

No

Comment

 


Kolumna InsertingPerson tabeli ExternalIdentifier

Definicja kolumny InsertingPerson tabeli ExternalIdentifier

Name

InsertingPerson

Code

InsertingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

PL: Osoba wstawiajaca rekord
EN: Person inserting record


Kolumna InsertDate tabeli ExternalIdentifier

Definicja kolumny InsertDate tabeli ExternalIdentifier

Name

InsertDate

Code

InsertDate

Data Type

DATE

Mandatory

No

Comment

PL: Data wstawienia rekordu
EN: Insert date of record
DE: Das Date der Ansatzstelle fur den Rekord


Kolumna LastModifiedPerson tabeli ExternalIdentifier

Definicja kolumny LastModifiedPerson tabeli ExternalIdentifier

Name

LastModifiedPerson

Code

LastModifiedPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna LastModifiedDT tabeli ExternalIdentifier

Definicja kolumny LastModifiedDT tabeli ExternalIdentifier

Name

LastModifiedDT

Code

LastModifiedDT

Data Type

DATE

Mandatory

No

Comment

Data ostatniej modyfikacji


Kolumna RemovingPerson tabeli ExternalIdentifier

Definicja kolumny RemovingPerson tabeli ExternalIdentifier

Name

RemovingPerson

Code

RemovingPerson

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Prefix tabeli ExternalIdentifier

Definicja kolumny Prefix tabeli ExternalIdentifier

Name

Prefix

Code

Prefix

Data Type

VARCHAR2(13)

Mandatory

No

Comment

 


Kolumna RotomatAddress tabeli ExternalIdentifier

Definicja kolumny RotomatAddress tabeli ExternalIdentifier

Name

RotomatAddress

Code

RotomatAddress

Data Type

VARCHAR2(9)

Mandatory

No

Comment

Lokalizacja dokumentacji w rotomacie


Kolumna OpenNumber tabeli ExternalIdentifier

Definicja kolumny OpenNumber tabeli ExternalIdentifier

Name

OpenNumber

Code

OpenNumber

Data Type

NUMBER(1)

Mandatory

Yes

Comment

Oznacza, czy dany numer ksiegi oddzialowej moze byc powtórnie uzyty


Kolumna Suffix tabeli ExternalIdentifier

Definicja kolumny Suffix tabeli ExternalIdentifier

Name

Suffix

Code

Suffix

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Lista kluczy tabeli ExternalIdentifier

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ExternalIdentifier

Definicja klucza Identifier_1 tabeli ExternalIdentifier

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment